Scatter Charts

Scatter charts compare two numeric values. The data styles for the subsequent examples is:

{
  "seats_by_distance": {
    "renderer": "scatter_chart"
  }
}

Run as a nested subtable

query: flights->{
  nest: seats_by_distance_scatter_chart is {
    group_by: seats is aircraft.aircraft_models.seats
    group_by: distance is distance
    aggregate: route_count is count(distinct concat(origin_code, destination_code))
  }
}

seats_by_distance_scatter_chart

Run as a trellis

query: flights->{
  group_by: origin_code
  nest: seats_by_distance_scatter_chart is {
    group_by: seats is aircraft.aircraft_models.seats
    group_by: distance is distance
    aggregate: route_count is count(distinct concat(origin_code, destination_code))
  }
}

origin_code	seats_by_distance_scatter_chart
ABE
ABI
ABQ
ABY
ACK